//package com.sync.syncmasterdata.customer.repository.wmsrep;
//
//import com.sync.syncmasterdata.customer.entity.wms.WmsCustomer;
//import org.springframework.data.jpa.repository.JpaRepository;
//import org.springframework.data.jpa.repository.Query;
//import org.springframework.data.repository.query.Param;
//import org.springframework.stereotype.Repository;
//
///**
// * wms客户 持久类
// */
//@Repository
//public interface WmsCustomerRepository extends JpaRepository<WmsCustomer,String> {
//
//    /**
//     * 获取最后一个客户编码，返回编码
//     * @return
//     */
//    @Query(nativeQuery = true, value= "select top 1 sCode from ele_customer order by scode desc")
//    String getLastCodeId();
//
//    /**
//     * 获取客户分类信息
//     */
//    @Query(nativeQuery = true, value= "select top 1 sCode from Sis_CustomerClass where uOrgId='C4ECB299-0803-4CBA-8895-51A2F1F5C661' and sName=:sName")
//    String getKhClass(@Param(value = "sName") String sName);
//
//    /**
//     * 获取客户信息
//     * @param sName
//     * @return
//     */
//    @Query(nativeQuery = true, value= "select top 1 uGuid1 from ele_customer where uOrgId='C4ECB299-0803-4CBA-8895-51A2F1F5C661' and sName=:sName")
//    String getKhInfo(@Param(value = "sName") String sName);
//
//}
